JDesignerPro Add Search Panel
[Back]
The Add Search Panel screen allows you to choose the elements by which to order searches on your forms. What you are building here is a pull down menu. This pull down will have a list of columns that can be searched. This panel is optional. To skip it, simply press the Add Result List tab.

The steps include:

  1. Double-click a column in the list. A default list of search terms will appear.
  2. If desired, change the Description in Pulldown to something other than the column name.
  3. You may add search terms and their corresponding SQL values in the table. The left side of the table is for the description of the matches that will appear when the selected column is chosen from the pull down. The right side of the table is for the actual SQL equivalent of the description.

    For example, the "Matching Descriptions" side might say "Greater Than" and in the "Values" (right hand) side of the table is ">", the corresponding SQL symbol. If you are unfamiliar with SQL, use the default values.

    You may not want to allow search terms to be entered. Another type of search pull-down list includes set values. For example you might have a column named Status. In the Matching values table you could have Active, Inactive, Pending. The corresponding SQL terms might be ='A', ='I', ='P'. Where A, I and P are the actual values in the table which determine a user's status.

  4. The Constant entry required choice determines whether the user will have a field in which to type a search term. Each column you select has a separate setting for this.
  5. The Make this the intial choice field determines which column will appear first in the search pull down.
Press the Reset button if you want to undo all your selections and changes. Once you have setup all your searchable columns, press Accept.

Now press the Add result List tab.
[Back]